﻿
CREATE PROCEDURE [dbo].[OPM_ReturnOrderDetail_Delete]
(
	@Id int,
	@DeletedBy int
)

AS

    UPDATE dbo.[OPM_ReturnOrderDetail]
	SET 
		[ProductNumber] = [ProductNumber]+'_Deleted',
		[Deleted] = 1,
		[UpdatedBy] = @DeletedBy,
		[UpdatedOn] = getdate()
	WHERE [Id] = @Id